How to: Find the entire contents of a selection using Filter by Selection.
Solution:
In the Table Datasheet view, select an entire field, and use the 'Filter By Selection' command on the 'Filter' submenu under the 'Records' menu.
1) If the Database window is not active, activate the Database window.
2) Go to the Table Datasheet view.
3) Select the cell that contains the entry to search for.
NOTE: When a cell is selected, the filter returns the records with a field whose entire contents match the selected cell.
Entire fields
4) Select the 'Records' menu and select 'Filter'. (A submenu appears.)
5) Select 'Filter By Selection' from the 'Filter' submenu. (Only records containing the value in the field selected in step 3) remain in the datasheet.)
6) To view all entries in the table again, select the 'Records' menu and select 'Remove Filter/Sort'.
7) To reapply the previous existing filter, select the 'Records' menu and select 'Apply Filter/Sort'.
